Configuring Data Profiling

Data quality scores (DQ scores) enable you to measure your data's quality. A higher DQ score indicates better accuracy and completeness of the data. To provide data quality capabilities, Quest Data Intelligence (Quest DI) integrates Quest Data Quality as a data quality analysis partner. To run data quality profiling, you need to configure Quest Data Quality in your Quest DI application.

Configuring Quest Data Quality in Quest DI requires Client ID and Client Secret details available in your Quest Data Quality instance. To get configuration details, refer to the Accessing Quest Data Quality Configuration Details section.

Quest Data Quality supports Single Sign-On (SSO). For more information, refer to Quest Data Quality SSO guide.

To configure Quest Data Quality, follow these steps:

  1. Go to Application Menu > Settings > Miscellaneous Configurations.
    The Miscellaneous Configuration page appears.
  2. Click the Data Profiling Configuration tab.
    The Data Profiling Configuration tab appears.
    Dqlab Configuration Options
    Use the following options for setting up data profiling configuration:
    • Enable Native Profile: Use this option to enable and configure an Quest Data Quality profile to sync Quest DI and Quest Data Quality and profile data.
    • Enable DQ Fields: Use this option to display only the selected data quality parameters across the assets in your organization.
    • Enable DQLabs: Use this option to enable Quest Data Quality integration using connection details and schedule a sync job. For more information, refer to the Enabling DQLabs section.

Enabling DQLabs

To enable Quest Data Quality integration, follow these steps:

  1. On the Data Profiling Configuration tab, click Enable DQLabs.
  2. Click Icon Dqlab Edit.
    The DQLabs Configuration tab switches to edit mode and displays connection details.

    3. This configuration requires Client ID and Client Secret from your Quest Data Quality instance. To get configuration details from Quest Data Quality instance, refer to the Accessing Quest Data Quality Configuration Details section.

    Dqlab Configuration Expand

  3. Enter appropriate values in the fields. Refer to the following table for field descriptions:

    4. Field Name

    Description

    DQ Version

    Specifies the version of Data Quality.

    For example, 2.x, 3.x.

    Base URL (Private)

    Specifies the base URL of your Quest Data Quality instance

    For example, https://cloud.dqlabs.ai

    Public URL

    Specifies the public URL of your Quest Data Quality instance

    For example, https://cloud.dqlabs.ai

    Client Id

    Specifies the alphanumeric client ID of your Quest Data Quality instance

    For example, 2ax1x3xde-b8x8-4b134-aa08-xxx303p2b86f1fk

    Client Secret

    Specifies the client secret of your Quest Data Quality instance
  4. Click Icon Save Connetion Dq.
    The Quest Data Quality configuration is saved.

To test the configuration, click Icon Dqlabs Test Connection. If the connection with the Quest Data Quality instance is established successfully, then a success message appears.

You can now access Quest Data Quality from Quest DI. To access Quest Data Quality, go to Application Menu > Data Quality.

The next steps involve adding datasets and views in the Quest Data Quality and scheduling a Quest Data Quality job.

Accessing Quest Data Quality Configuration Details

To access Client ID and Client Key in your Quest Data Quality instance, follow these steps:

  1. Log in to Quest Data Quality.
    The Quest Data Quality instance opens.
  2. On the app menu, click Icon Dqlabs User > Settings.

    3. The Settings page appears.

    Dqlab Settings Page

  3. Click Icon Menu to expand menu.

    4. The menu expands and displays additional options.

    Expanded Menu

  4. Expand Security and click API.
    5. Menu Api Option

    The API section appears and displays the Client ID and Client Key.

    Api Clientid Clientkey
  5. Click Icon Copy to copy them.
  6. Paste these values into the Enabling DQ Labs section.

You can also create a new API key to generate a Client ID and Client Key.

To create a new API key, follow these steps:

  1. Click Icon Add Apikey.

    The ADD API KEY dialog box opens.

    Add Api Key Pop Up

  2. In the Name field, enter a name for the API key.

  3. Select the required option from the Expired In dropdown.

  4. Click Add.

    5. A new API key is created, and the Client ID and Client Key are generated.